//
//  AppDelegate.m
//  诗词鉴赏
//
//  Created by Steven on 2019/7/22.
//  Copyright © 2019 Steven. All rights reserved.
//

#import "AppDelegate.h"
#import "FMDB.h"
@interface AppDelegate ()
@property(nonatomic,strong)FMDatabase *dataBase;
@end

@implementation AppDelegate


- (BOOL)application:(UIApplication *)application didFinishLaunchingWithOptions:(NSDictionary *)launchOptions {
    NSString *path = [NSString stringWithFormat:@"%@/%@.db",[[NSBundle mainBundle] resourcePath], @"gushici"] ;
    
    self.dataBase = [FMDatabase databaseWithPath:path];
    if (![self.dataBase open ]){
        return false;
    }
    
    // 查找表 AllTheQustions
    FMResultSet* resultSet = [self.dataBase executeQuery: @"select * from shici" ];
    
    appData.shiciDatas = [NSMutableArray array];
    [appData.shiciDatas removeAllObjects];
    
    // 逐行读取数据
    while ([resultSet next] )
    {
        Shici *model = [[Shici alloc]init];
        model.idNum = [[resultSet objectForColumnName:@"id"] integerValue];
        model.title = [resultSet objectForColumnName:@"title"];
        model.content = [resultSet objectForColumnName:@"content"];
        model.author = [resultSet objectForColumnName:@"author"];
        
        NSString *str = [resultSet objectForColumnName:@"tag"];
        
        NSLog(@"%@", str);
        
        if (![str isKindOfClass:[NSNull class]]) {
            model.tagArr = [str componentsSeparatedByString:@"|"];
        }else{
            model.tagArr = [NSArray array];
        }
        model.fanyi = [resultSet objectForColumnName:@"fanyi"];
        model.zhushi = [resultSet objectForColumnName:@"zhushi"];
        model.pingxi = [resultSet objectForColumnName:@"pingxi"];
        model.chaodai = [resultSet objectForColumnName:@"chaodai"];
        [appData.shiciDatas addObject:model];
    }
    
    //作者数据
    FMResultSet* newResultSet = [self.dataBase executeQuery: @"select * from author" ];
    appData.authorDatas = [NSMutableArray array];
    [appData.authorDatas removeAllObjects];
    
    
    // 逐行读取数据
    while ([newResultSet next]){
        Author *model = [[Author alloc]init];
        model.idNum = [[newResultSet objectForColumnName:@"id"] integerValue];
        model.name = [newResultSet objectForColumnName:@"name"];
        model.intro = [newResultSet objectForColumnName:@"intro"];
        model.pic = [newResultSet objectForColumnName:@"pic"];
        model.chaodai = [newResultSet objectForColumnName:@"chaodai"];
        [appData.authorDatas addObject:model];
    }
    [self.dataBase close];
    return YES;
}


- (void)applicationWillResignActive:(UIApplication *)application {
    // Sent when the application is about to move from active to inactive state. This can occur for certain types of temporary interruptions (such as an incoming phone call or SMS message) or when the user quits the application and it begins the transition to the background state.
    // Use this method to pause ongoing tasks, disable timers, and invalidate graphics rendering callbacks. Games should use this method to pause the game.
}


- (void)applicationDidEnterBackground:(UIApplication *)application {
    // Use this method to release shared resources, save user data, invalidate timers, and store enough application state information to restore your application to its current state in case it is terminated later.
    // If your application supports background execution, this method is called instead of applicationWillTerminate: when the user quits.
}


- (void)applicationWillEnterForeground:(UIApplication *)application {
    // Called as part of the transition from the background to the active state; here you can undo many of the changes made on entering the background.
}


- (void)applicationDidBecomeActive:(UIApplication *)application {
    // Restart any tasks that were paused (or not yet started) while the application was inactive. If the application was previously in the background, optionally refresh the user interface.
}


- (void)applicationWillTerminate:(UIApplication *)application {
    // Called when the application is about to terminate. Save data if appropriate. See also applicationDidEnterBackground:.
}


@end
